<?php
if (!defined('sugarEntry') || !sugarEntry)
    die('Not A Valid Entry Point');


function get_fees_query($params) {
	require_once('modules/edanz_Deliverables/edanz_Deliverables.php');
	$deliverable = new edanz_Deliverables();
	$deliverable->retrieve($params['deliverable_id']);

	$return_array['select'] = " SELECT edanz_fees.id ";
	$return_array['from'] = " FROM edanz_fees ";
	$return_array['join'] = " LEFT JOIN tasks ON tasks.id = edanz_fees.task_id and tasks.deleted = 0 and edanz_fees.deleted = 0";
	$return_array['where'] = " tasks.deliverable_id = '" . $deliverable->id . "'";
	return $return_array;
}


?>
